package servlet;
import servlet.Connections;
import java.util.*;
import java.sql.*;
import java.io.*;
public class selectDeveloper 
{
	ArrayList developerlist=new ArrayList();
	Connections conn=new Connections();
	Statement stmt=null;
	ResultSet rs=null;
	String query;
	public ArrayList getDeveloperList()
	{
		try
		{
			query="select * from developer";
			stmt=conn.getConnection().createStatement();
			rs=stmt.executeQuery(query);
			while(rs.next())
			{
				developerlist.add(rs.getString(2));
			}
			rs.close();
			stmt.close();
			conn.getConnection().close();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		
		return developerlist;
	}

}
